POST api/v1/dataservice/getdatarows/{tableName}?fieldList[0]={fieldList[0]}&fieldList[1]={fieldList[1]}

Gets Data Rows for the provided Row Ids.

Request Information

URI Parameters

NameDescriptionTypeAdditional information
tableName

Name of the table to search.

 string

Required
fieldList

The list of fields to return. (optional). If empty, all fields will be returned

 Collection of string

Required

Body Parameters

List of row id's to retrieve.

Collection of string

Request Formats

application/json, text/json

Sample: 
[
  "sample string 1",
  "sample string 2"
]

application/xml, text/xml

Sample: 
<ArrayOfstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
  <string>sample string 1</string>
  <string>sample string 2</string>
</ArrayOfstring>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'List`1'.

Response Information

Resource Description

PcSafeData
NameDescriptionTypeAdditional information
TransactionId

string

None.
PagingData

PagingData

None.
DataEntities

Collection of DataEntity

None.

Response Formats

application/json, text/json

Sample: 
{
  "TransactionId": "sample string 1",
  "PagingData": {
    "PageSize": 1,
    "PageIndex": 2,
    "TotalRecords": 3,
    "TotalPages": 4,
    "Token": "sample string 5"
  },
  "DataEntities": [
    {
      "RefId": "sample string 1",
      "RowId": "sample string 2",
      "Fields": [
        {
          "Name": "sample string 1",
          "Value": "sample string 2"
        },
        {
          "Name": "sample string 1",
          "Value": "sample string 2"
        }
      ]
    },
    {
      "RefId": "sample string 1",
      "RowId": "sample string 2",
      "Fields": [
        {
          "Name": "sample string 1",
          "Value": "sample string 2"
        },
        {
          "Name": "sample string 1",
          "Value": "sample string 2"
        }
      ]
    }
  ]
}

application/xml, text/xml

Sample: 
<PcSafeData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Paperclip.IOTA.WebApi.Model">
  <DataEntities>
    <DataEntity>
      <Fields>
        <DataField>
          <Name>sample string 1</Name>
          <Value>sample string 2</Value>
        </DataField>
        <DataField>
          <Name>sample string 1</Name>
          <Value>sample string 2</Value>
        </DataField>
      </Fields>
      <RefId>sample string 1</RefId>
      <RowId>sample string 2</RowId>
    </DataEntity>
    <DataEntity>
      <Fields>
        <DataField>
          <Name>sample string 1</Name>
          <Value>sample string 2</Value>
        </DataField>
        <DataField>
          <Name>sample string 1</Name>
          <Value>sample string 2</Value>
        </DataField>
      </Fields>
      <RefId>sample string 1</RefId>
      <RowId>sample string 2</RowId>
    </DataEntity>
  </DataEntities>
  <PagingData>
    <PageIndex>2</PageIndex>
    <PageSize>1</PageSize>
    <Token>sample string 5</Token>
    <TotalPages>4</TotalPages>
    <TotalRecords>3</TotalRecords>
  </PagingData>
  <TransactionId>sample string 1</TransactionId>
</PcSafeData>